<?php

include 'db.php';

$db = db::getInstance()->connect();

$result = $db->query("select * from category");
while ($row = $result->fetch_assoc()) {
    echo $row['id'] . ':' . $row['category'] . '<br>';
}